// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.


suite("test_cast_to_decimal64_18_9_from_str") {

    // This test case is generated from the correspoinding be UT test case,
    // update this case if the correspoinding be UT test case is updated,
    // e.g.: ../run-be-ut.sh --run --filter=FunctionCastToDecimalTest.* --gen_regression_case
    sql "drop table if exists test_cast_to_decimal64_18_9_from_str_15_nullable;"
    sql "create table test_cast_to_decimal64_18_9_from_str_15_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal64_18_9_from_str_15_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "99999999"),(6, "900000000"),(7, "900000001"),(8, "999999998"),(9, "999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "99999999."),(14, "900000000."),(15, "900000001."),(16, "999999998."),(17, "999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-99999999"),(22, "-900000000"),(23, "-900000001"),(24, "-999999998"),(25, "-999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-99999999."),(30, "-900000000."),(31, "-900000001."),(32, "-999999998."),(33, "-999999999."),(34, ".0000000004"),(35, ".0000000014"),(36, ".0000000094"),(37, ".0999999994"),(38, ".9000000004"),(39, ".9000000014"),
      (40, ".9999999984"),(41, ".9999999994"),(42, ".0000000005"),(43, ".0000000015"),(44, ".0000000095"),(45, ".0999999995"),(46, ".9000000005"),(47, ".9000000015"),(48, ".9999999985"),(49, ".9999999994"),(50, "-.0000000004"),(51, "-.0000000014"),(52, "-.0000000094"),(53, "-.0999999994"),(54, "-.9000000004"),(55, "-.9000000014"),(56, "-.9999999984"),(57, "-.9999999994"),(58, "-.0000000005"),(59, "-.0000000015"),
      (60, "-.0000000095"),(61, "-.0999999995"),(62, "-.9000000005"),(63, "-.9000000015"),(64, "-.9999999985"),(65, "-.9999999994"),(66, "00000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "9000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "9000000000000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "9000000000000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "9000000000999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "9000000009000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "9000000009000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "9000000009999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "9000000009999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "9000000010000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "9000000010000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "9000000010000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "9000000010999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "9000000019000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "9000000019000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "9000000019999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "9000000019999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "9999999980000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "9999999980000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "9999999980000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "9999999980999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "9999999989000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "9999999989000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "9999999989999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "9999999989999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "999999990000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "999999990000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "999999990000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "999999990999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "999999999000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "999999999000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "999999999999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "999999999999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "9000000000000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "9000000000000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "9000000000000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "9000000000999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "9000000009000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "9000000009000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "9000000009999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "9000000009999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "9000000010000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "9000000010000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "9000000010000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "9000000010999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "9000000019000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "9000000019000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "9000000019999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "9000000019999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "9999999980000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "9999999980000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "9999999980000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "9999999980999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "9999999989000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "9999999989000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "9999999989999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "9999999989999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-9000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-9000000000000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-9000000000000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-9000000000999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-9000000009000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-9000000009000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-9000000009999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-9000000009999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-9000000010000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-9000000010000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-9000000010000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-9000000010999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-9000000019000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-9000000019000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-9000000019999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-9000000019999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-9999999980000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-9999999980000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-9999999980000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-9999999980999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-9999999989000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-9999999989000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-9999999989999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-9999999989999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-999999990000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-999999990000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-999999990000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-999999990999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-999999999000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-999999999000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-999999999999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-999999999999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-9000000000000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-9000000000000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-9000000000000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-9000000000999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-9000000009000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-9000000009000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-9000000009999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-9000000009999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-9000000010000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-9000000010000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-9000000010000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-9000000010999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-9000000019000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-9000000019000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-9000000019999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-9000000019999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-9999999980000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-9999999980000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-9999999980000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-9999999980999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-9999999989000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-9999999989000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-9999999989999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-9999999989999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100")
      ,(322, null);
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(18, 9)) from test_cast_to_decimal64_18_9_from_str_15_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(18, 9)) from test_cast_to_decimal64_18_9_from_str_15_nullable order by 1;'

    sql "drop table if exists test_cast_to_decimal64_18_9_from_str_15_not_nullable;"
    sql "create table test_cast_to_decimal64_18_9_from_str_15_not_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal64_18_9_from_str_15_not_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "99999999"),(6, "900000000"),(7, "900000001"),(8, "999999998"),(9, "999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "99999999."),(14, "900000000."),(15, "900000001."),(16, "999999998."),(17, "999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-99999999"),(22, "-900000000"),(23, "-900000001"),(24, "-999999998"),(25, "-999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-99999999."),(30, "-900000000."),(31, "-900000001."),(32, "-999999998."),(33, "-999999999."),(34, ".0000000004"),(35, ".0000000014"),(36, ".0000000094"),(37, ".0999999994"),(38, ".9000000004"),(39, ".9000000014"),
      (40, ".9999999984"),(41, ".9999999994"),(42, ".0000000005"),(43, ".0000000015"),(44, ".0000000095"),(45, ".0999999995"),(46, ".9000000005"),(47, ".9000000015"),(48, ".9999999985"),(49, ".9999999994"),(50, "-.0000000004"),(51, "-.0000000014"),(52, "-.0000000094"),(53, "-.0999999994"),(54, "-.9000000004"),(55, "-.9000000014"),(56, "-.9999999984"),(57, "-.9999999994"),(58, "-.0000000005"),(59, "-.0000000015"),
      (60, "-.0000000095"),(61, "-.0999999995"),(62, "-.9000000005"),(63, "-.9000000015"),(64, "-.9999999985"),(65, "-.9999999994"),(66, "00000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "9000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "9000000000000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "9000000000000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "9000000000999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "9000000009000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "9000000009000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "9000000009999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "9000000009999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "9000000010000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "9000000010000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "9000000010000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "9000000010999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "9000000019000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "9000000019000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "9000000019999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "9000000019999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "9999999980000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "9999999980000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "9999999980000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "9999999980999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "9999999989000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "9999999989000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "9999999989999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "9999999989999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "999999990000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "999999990000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "999999990000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "999999990999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "999999999000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "999999999000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "999999999999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "999999999999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "9000000000000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "9000000000000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "9000000000000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "9000000000999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "9000000009000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "9000000009000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "9000000009999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "9000000009999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "9000000010000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "9000000010000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "9000000010000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "9000000010999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "9000000019000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "9000000019000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "9000000019999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "9000000019999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "9999999980000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "9999999980000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "9999999980000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "9999999980999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "9999999989000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "9999999989000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "9999999989999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "9999999989999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-9000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-9000000000000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-9000000000000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-9000000000999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-9000000009000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-9000000009000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-9000000009999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-9000000009999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-9000000010000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-9000000010000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-9000000010000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-9000000010999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-9000000019000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-9000000019000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-9000000019999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-9000000019999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-9999999980000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-9999999980000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-9999999980000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-9999999980999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-9999999989000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-9999999989000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-9999999989999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-9999999989999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-999999990000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-999999990000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-999999990000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-999999990999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-999999999000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-999999999000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-999999999999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-999999999999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-9000000000000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-9000000000000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-9000000000000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-9000000000999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-9000000009000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-9000000009000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-9000000009999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-9000000009999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-9000000010000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-9000000010000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-9000000010000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-9000000010999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-9000000019000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-9000000019000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-9000000019999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-9000000019999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-9999999980000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-9999999980000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-9999999980000000095000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-9999999980999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-9999999989000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-9999999989000000015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-9999999989999999985000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-9999999989999999995000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-9999999990000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-9999999990000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-9999999990000000094000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-9999999990999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-9999999999000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-9999999999000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-9999999999999999984000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-9999999999999999994000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.e-100");
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(18, 9)) from test_cast_to_decimal64_18_9_from_str_15_not_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(18, 9)) from test_cast_to_decimal64_18_9_from_str_15_not_nullable order by 1;'

}